2015-01-28 - 16850.200 - Enhancement - Add Year Group to SA170 report #CrystalReportsSupport
Enhancement
16850.200 - Add Year Group to SA170 report
Requirement Summary
Need to add Year Group to SA170 report.
Admin Info
Purpose
|
Need to add Year Group to SA170 report.
|
Requested By
|
Karen Stritch
|
Spec Created By
|
Dhananjay
|
Spec Created Date
|
01/28/2015
|
Spec QA by
|
Uday Kumar P
|
Objects
|
SA170
|
Document Status
|
Complete
|
Estimates
SNo
|
Activity
|
Estimation in Hours
|
1
|
Research
|
00
|
2
|
Documentation
|
08
|
3
|
Development/ Config
|
30
|
4
|
Unit test in DEV
|
08
|
5
|
Unit test in QUA
|
00
|
6
|
Other activity
|
14
|
|
TOTAL
|
60
|
References
Prior Tickets
16850
Documents
SA170_FunctionalSpec_01282015.docx
Spec Changes
SNo
|
Change Details
|
Requested By
|
Requested On
|
Notes if any
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Functional Requirement
Purpose/WHY:
As the year progresses and orders begin to fill in for the upcoming year users need to have visibility into that data.
In Scope:
Need to add Year Group to SA170 report.
Out of Scope:
None
Solution Summary
1. Need to add a year group to SA170 report.
2. This group should be placed above the Region group in this report(similar to the OSA110 report) and allow the user to drill into the Current year or the Current year + 1. The resulting data set would display the selected and previous year (i.e 2015 / 2014 or 2016 / 2015).
3. Need to add the year option to the existing groups.
4. Need to develop regional versions of this report(GLOBAL, EMEA, NORTH AMERICA, JAPAN, EMERGING APAC & EMERGING LATIN AMERICA).
5. Need to check if the report is maintained with current format within the groups, the data in the Shipped, Open, Total, Last Year.. etc fields.
6. Need to check if SA170 report meets all the required changes specified by NEC.
Test Plan
Test ID
|
Test Scenario
|
Expected Results
|
1
|
Report Format.
|
Should be as per NEC crystal standard checklist.
|
2
|
Execute Crystal Report in Crystal Designer tool after changes.
|
Report should execute successfully in Crystal Designer tool.
|
3
|
Schedule the Report in NEC BI Launch Pad.
|
Report should execute successfully in NEC BI Launch Pad.
|
Solution Details
1. Need to add a year group to SA170 report.
2. This group should be placed above the Region group in this report(similar to the OSA110 report) and allow the user to drill into the Current year or the Current year + 1. The resulting data set would display the selected and previous year (i.e 2015 / 2014 or 2016 / 2015).
3. Need to add the year option to the existing groups.
4. Need to develop regional versions of this report(GLOBAL, EMEA, NORTH AMERICA, JAPAN, EMERGING APAC & EMERGING LATIN AMERICA).
5. Need to check if the report is maintained with current format within the groups, the data in the Shipped, Open, Total, Last Year.. etc fields.
6. Need to check if SA170 report meets all the required changes specified by NEC.
Issues
None
the year option to the groups